﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="EmployeeInfoDataSet1" targetNamespace="http://tempuri.org/EmployeeInfoDataSet1.xsd" xmlns:mstns="http://tempuri.org/EmployeeInfoDataSet1.xsd" xmlns="http://tempuri.org/EmployeeInfoDataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="EmployeeInfoConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="EmployeeInfoConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DreametryMIS.Properties.Settings.GlobalReference.Default.EmployeeInfoConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Emp_TaskTableAdapter" GeneratorDataComponentClassName="Emp_TaskTableAdapter" Name="Emp_Task" UserDataComponentName="Emp_TaskTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EmployeeInfoConnectionString1 (Settings)" DbObjectName="EmployeeInfo.dbo.Emp_Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Emp_Task] WHERE (([emptask_id] = @Original_emptask_id) AND ([emp_id] = @Original_emp_id) AND ([task_id] = @Original_task_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emptask_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emptask_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Emp_Task] ([emp_id], [task_id]) VALUES (@emp_id, @task_id);
SELECT emptask_id, emp_id, task_id FROM Emp_Task WHERE (emptask_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT emptask_id, emp_id, task_id FROM dbo.Emp_Task</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Emp_Task] SET [emp_id] = @emp_id, [task_id] = @task_id WHERE (([emptask_id] = @Original_emptask_id) AND ([emp_id] = @Original_emp_id) AND ([task_id] = @Original_task_id));
SELECT emptask_id, emp_id, task_id FROM Emp_Task WHERE (emptask_id = @emptask_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emptask_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emptask_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="emptask_id" ColumnName="emptask_id" DataSourceName="EmployeeInfo.dbo.Emp_Task" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@emptask_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="emptask_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="emptask_id" DataSetColumn="emptask_id" />
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeeTableAdapter" GeneratorDataComponentClassName="EmployeeTableAdapter" Name="Employee" UserDataComponentName="EmployeeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EmployeeInfoConnectionString1 (Settings)" DbObjectName="EmployeeInfo.dbo.Employee" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Employee] WHERE (([emp_id] = @Original_emp_id) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_taskInProgress = 1 AND [taskInProgress] IS NULL) OR ([taskInProgress] = @Original_taskInProgress)) AND ((@IsNull_role_id = 1 AND [role_id] IS NULL) OR ([role_id] = @Original_role_id)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taskInProgress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskInProgress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taskInProgress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taskInProgress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_role_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="role_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_role_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="role_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Employee] ([Name], [taskInProgress], [role_id]) VALUES (@Name, @taskInProgress, @role_id);
SELECT emp_id, Name, taskInProgress, role_id FROM Employee WHERE (emp_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taskInProgress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taskInProgress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@role_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="role_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT emp_id, Name, taskInProgress, role_id FROM dbo.Employee</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Employee] SET [Name] = @Name, [taskInProgress] = @taskInProgress, [role_id] = @role_id WHERE (([emp_id] = @Original_emp_id) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_taskInProgress = 1 AND [taskInProgress] IS NULL) OR ([taskInProgress] = @Original_taskInProgress)) AND ((@IsNull_role_id = 1 AND [role_id] IS NULL) OR ([role_id] = @Original_role_id)));
SELECT emp_id, Name, taskInProgress, role_id FROM Employee WHERE (emp_id = @emp_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@taskInProgress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taskInProgress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@role_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="role_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_taskInProgress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="taskInProgress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_taskInProgress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="taskInProgress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_role_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="role_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_role_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="role_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="emp_id" ColumnName="emp_id" DataSourceName="EmployeeInfo.dbo.Employee" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="taskInProgress" DataSetColumn="taskInProgress" />
              <Mapping SourceColumn="role_id" DataSetColumn="role_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmpRoleTableAdapter" GeneratorDataComponentClassName="EmpRoleTableAdapter" Name="EmpRole" UserDataComponentName="EmpRoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EmployeeInfoConnectionString1 (Settings)" DbObjectName="EmployeeInfo.dbo.EmpRole" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EmpRole] WHERE (([role_id] = @Original_role_id) AND ((@IsNull_emp_role = 1 AND [emp_role] IS NULL) OR ([emp_role] = @Original_emp_role)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_role_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="role_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_emp_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_emp_role" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="emp_role" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EmpRole] ([emp_role]) VALUES (@emp_role);
SELECT role_id, emp_role FROM EmpRole WHERE (role_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@emp_role" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="emp_role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT role_id, emp_role FROM dbo.EmpRole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EmpRole] SET [emp_role] = @emp_role WHERE (([role_id] = @Original_role_id) AND ((@IsNull_emp_role = 1 AND [emp_role] IS NULL) OR ([emp_role] = @Original_emp_role)));
SELECT role_id, emp_role FROM EmpRole WHERE (role_id = @role_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@emp_role" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="emp_role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_role_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="role_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_emp_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_emp_role" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="emp_role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="role_id" ColumnName="role_id" DataSourceName="EmployeeInfo.dbo.EmpRole" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@role_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="role_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="role_id" DataSetColumn="role_id" />
              <Mapping SourceColumn="emp_role" DataSetColumn="emp_role" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaskTableTableAdapter" GeneratorDataComponentClassName="TaskTableTableAdapter" Name="TaskTable" UserDataComponentName="TaskTableTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EmployeeInfoConnectionString1 (Settings)" DbObjectName="EmployeeInfo.dbo.TaskTable" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TaskTable] WHERE (([task_id] = @Original_task_id) AND ((@IsNull_task_name = 1 AND [task_name] IS NULL) OR ([task_name] = @Original_task_name)) AND ((@IsNull_date = 1 AND [date] IS NULL) OR ([date] = @Original_date)) AND ([flow_id] = @Original_flow_id) AND ([emp_id] = @Original_emp_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_task_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_task_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="task_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_flow_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flow_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TaskTable] ([task_name], [task_description], [output_description], [date], [flow_id], [emp_id]) VALUES (@task_name, @task_description, @output_description, @date, @flow_id, @emp_id);
SELECT task_id, task_name, task_description, output_description, date, flow_id, emp_id FROM TaskTable WHERE (task_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@task_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="task_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@task_description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="task_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@output_description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="output_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@flow_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flow_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT task_id, task_name, task_description, output_description, date, flow_id, emp_id FROM dbo.TaskTable</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TaskTable] SET [task_name] = @task_name, [task_description] = @task_description, [output_description] = @output_description, [date] = @date, [flow_id] = @flow_id, [emp_id] = @emp_id WHERE (([task_id] = @Original_task_id) AND ((@IsNull_task_name = 1 AND [task_name] IS NULL) OR ([task_name] = @Original_task_name)) AND ((@IsNull_date = 1 AND [date] IS NULL) OR ([date] = @Original_date)) AND ([flow_id] = @Original_flow_id) AND ([emp_id] = @Original_emp_id));
SELECT task_id, task_name, task_description, output_description, date, flow_id, emp_id FROM TaskTable WHERE (task_id = @task_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@task_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="task_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@task_description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="task_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@output_description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="output_description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@flow_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flow_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_task_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_task_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="task_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_task_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="task_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_flow_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flow_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_emp_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="emp_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="task_id" ColumnName="task_id" DataSourceName="EmployeeInfo.dbo.TaskTable" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@task_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="task_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
              <Mapping SourceColumn="task_name" DataSetColumn="task_name" />
              <Mapping SourceColumn="task_description" DataSetColumn="task_description" />
              <Mapping SourceColumn="output_description" DataSetColumn="output_description" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="flow_id" DataSetColumn="flow_id" />
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkFlowTableAdapter" GeneratorDataComponentClassName="WorkFlowTableAdapter" Name="WorkFlow" UserDataComponentName="WorkFlowTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EmployeeInfoConnectionString1 (Settings)" DbObjectName="EmployeeInfo.dbo.WorkFlow" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[WorkFlow] WHERE (([flow_id] = @Original_flow_id) AND ((@IsNull_flowStatus = 1 AND [flowStatus] IS NULL) OR ([flowStatus] = @Original_flowStatus)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_flow_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flow_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_flowStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flowStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_flowStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="flowStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[WorkFlow] ([flow_id], [flowStatus]) VALUES (@flow_id, @flowStatus);
SELECT flow_id, flowStatus FROM WorkFlow WHERE (flow_id = @flow_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@flow_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flow_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@flowStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="flowStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT flow_id, flowStatus FROM dbo.WorkFlow</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[WorkFlow] SET [flow_id] = @flow_id, [flowStatus] = @flowStatus WHERE (([flow_id] = @Original_flow_id) AND ((@IsNull_flowStatus = 1 AND [flowStatus] IS NULL) OR ([flowStatus] = @Original_flowStatus)));
SELECT flow_id, flowStatus FROM WorkFlow WHERE (flow_id = @flow_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@flow_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flow_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@flowStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="flowStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_flow_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flow_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_flowStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="flowStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_flowStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="flowStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="flow_id" DataSetColumn="flow_id" />
              <Mapping SourceColumn="flowStatus" DataSetColumn="flowStatus" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmploeeTaskTableAdapter" GeneratorDataComponentClassName="EmploeeTaskTableAdapter" Name="EmploeeTask" UserDataComponentName="EmploeeTaskTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EmployeeInfoConnectionString1 (Settings)" DbObjectName="EmployeeInfo.dbo.EmploeeTask" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT emp_id, Name, task_name, task_id, task_description, output_description, flow_id, flowStatus FROM dbo.EmploeeTask</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="task_name" DataSetColumn="task_name" />
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
              <Mapping SourceColumn="task_description" DataSetColumn="task_description" />
              <Mapping SourceColumn="output_description" DataSetColumn="output_description" />
              <Mapping SourceColumn="flow_id" DataSetColumn="flow_id" />
              <Mapping SourceColumn="flowStatus" DataSetColumn="flowStatus" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeeRoleTableAdapter" GeneratorDataComponentClassName="EmployeeRoleTableAdapter" Name="EmployeeRole" UserDataComponentName="EmployeeRoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EmployeeInfoConnectionString1 (Settings)" DbObjectName="EmployeeInfo.dbo.EmployeeRole" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Name, role_id, emp_role FROM dbo.EmployeeRole</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="role_id" DataSetColumn="role_id" />
              <Mapping SourceColumn="emp_role" DataSetColumn="emp_role" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ViewAdminTableAdapter" GeneratorDataComponentClassName="ViewAdminTableAdapter" Name="ViewAdmin" UserDataComponentName="ViewAdminTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="EmployeeInfoConnectionString1 (Settings)" DbObjectName="EmployeeInfo.dbo.ViewAdmin" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT emp_id, Name, taskInProgress, task_id, task_name, task_description, output_description, date, flow_id, flowStatus FROM dbo.ViewAdmin</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="emp_id" DataSetColumn="emp_id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="taskInProgress" DataSetColumn="taskInProgress" />
              <Mapping SourceColumn="task_id" DataSetColumn="task_id" />
              <Mapping SourceColumn="task_name" DataSetColumn="task_name" />
              <Mapping SourceColumn="task_description" DataSetColumn="task_description" />
              <Mapping SourceColumn="output_description" DataSetColumn="output_description" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="flow_id" DataSetColumn="flow_id" />
              <Mapping SourceColumn="flowStatus" DataSetColumn="flowStatus" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="EmployeeInfoDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="EmployeeInfoDataSet1" msprop:Generator_UserDSName="EmployeeInfoDataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Emp_Task" msprop:Generator_TableClassName="Emp_TaskDataTable" msprop:Generator_TableVarName="tableEmp_Task" msprop:Generator_TablePropName="Emp_Task" msprop:Generator_RowDeletingName="Emp_TaskRowDeleting" msprop:Generator_RowChangingName="Emp_TaskRowChanging" msprop:Generator_RowEvHandlerName="Emp_TaskRowChangeEventHandler" msprop:Generator_RowDeletedName="Emp_TaskRowDeleted" msprop:Generator_UserTableName="Emp_Task" msprop:Generator_RowChangedName="Emp_TaskRowChanged" msprop:Generator_RowEvArgName="Emp_TaskRowChangeEvent" msprop:Generator_RowClassName="Emp_TaskRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emptask_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnemptask_id" msprop:Generator_ColumnPropNameInRow="emptask_id" msprop:Generator_ColumnPropNameInTable="emptask_idColumn" msprop:Generator_UserColumnName="emptask_id" type="xs:int" />
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="task_id" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Employee" msprop:Generator_TableClassName="EmployeeDataTable" msprop:Generator_TableVarName="tableEmployee" msprop:Generator_TablePropName="Employee" msprop:Generator_RowDeletingName="EmployeeRowDeleting" msprop:Generator_RowChangingName="EmployeeRowChanging" msprop:Generator_RowEvHandlerName="EmployeeRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeeRowDeleted" msprop:Generator_UserTableName="Employee" msprop:Generator_RowChangedName="EmployeeRowChanged" msprop:Generator_RowEvArgName="EmployeeRowChangeEvent" msprop:Generator_RowClassName="EmployeeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emp_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taskInProgress" msprop:Generator_ColumnVarNameInTable="columntaskInProgress" msprop:Generator_ColumnPropNameInRow="taskInProgress" msprop:Generator_ColumnPropNameInTable="taskInProgressColumn" msprop:Generator_UserColumnName="taskInProgress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="role_id" msprop:Generator_ColumnVarNameInTable="columnrole_id" msprop:Generator_ColumnPropNameInRow="role_id" msprop:Generator_ColumnPropNameInTable="role_idColumn" msprop:Generator_UserColumnName="role_id" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EmpRole" msprop:Generator_TableClassName="EmpRoleDataTable" msprop:Generator_TableVarName="tableEmpRole" msprop:Generator_TablePropName="EmpRole" msprop:Generator_RowDeletingName="EmpRoleRowDeleting" msprop:Generator_RowChangingName="EmpRoleRowChanging" msprop:Generator_RowEvHandlerName="EmpRoleRowChangeEventHandler" msprop:Generator_RowDeletedName="EmpRoleRowDeleted" msprop:Generator_UserTableName="EmpRole" msprop:Generator_RowChangedName="EmpRoleRowChanged" msprop:Generator_RowEvArgName="EmpRoleRowChangeEvent" msprop:Generator_RowClassName="EmpRoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="role_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnrole_id" msprop:Generator_ColumnPropNameInRow="role_id" msprop:Generator_ColumnPropNameInTable="role_idColumn" msprop:Generator_UserColumnName="role_id" type="xs:int" />
              <xs:element name="emp_role" msprop:Generator_ColumnVarNameInTable="columnemp_role" msprop:Generator_ColumnPropNameInRow="emp_role" msprop:Generator_ColumnPropNameInTable="emp_roleColumn" msprop:Generator_UserColumnName="emp_role" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TaskTable" msprop:Generator_TableClassName="TaskTableDataTable" msprop:Generator_TableVarName="tableTaskTable" msprop:Generator_TablePropName="TaskTable" msprop:Generator_RowDeletingName="TaskTableRowDeleting" msprop:Generator_RowChangingName="TaskTableRowChanging" msprop:Generator_RowEvHandlerName="TaskTableRowChangeEventHandler" msprop:Generator_RowDeletedName="TaskTableRowDeleted" msprop:Generator_UserTableName="TaskTable" msprop:Generator_RowChangedName="TaskTableRowChanged" msprop:Generator_RowEvArgName="TaskTableRowChangeEvent" msprop:Generator_RowClassName="TaskTableRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="task_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
              <xs:element name="task_name" msprop:Generator_ColumnVarNameInTable="columntask_name" msprop:Generator_ColumnPropNameInRow="task_name" msprop:Generator_ColumnPropNameInTable="task_nameColumn" msprop:Generator_UserColumnName="task_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="task_description" msprop:Generator_ColumnVarNameInTable="columntask_description" msprop:Generator_ColumnPropNameInRow="task_description" msprop:Generator_ColumnPropNameInTable="task_descriptionColumn" msprop:Generator_UserColumnName="task_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="output_description" msprop:Generator_ColumnVarNameInTable="columnoutput_description" msprop:Generator_ColumnPropNameInRow="output_description" msprop:Generator_ColumnPropNameInTable="output_descriptionColumn" msprop:Generator_UserColumnName="output_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="flow_id" msprop:Generator_ColumnVarNameInTable="columnflow_id" msprop:Generator_ColumnPropNameInRow="flow_id" msprop:Generator_ColumnPropNameInTable="flow_idColumn" msprop:Generator_UserColumnName="flow_id" type="xs:int" />
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkFlow" msprop:Generator_TableClassName="WorkFlowDataTable" msprop:Generator_TableVarName="tableWorkFlow" msprop:Generator_TablePropName="WorkFlow" msprop:Generator_RowDeletingName="WorkFlowRowDeleting" msprop:Generator_RowChangingName="WorkFlowRowChanging" msprop:Generator_RowEvHandlerName="WorkFlowRowChangeEventHandler" msprop:Generator_RowDeletedName="WorkFlowRowDeleted" msprop:Generator_UserTableName="WorkFlow" msprop:Generator_RowChangedName="WorkFlowRowChanged" msprop:Generator_RowEvArgName="WorkFlowRowChangeEvent" msprop:Generator_RowClassName="WorkFlowRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="flow_id" msprop:Generator_ColumnVarNameInTable="columnflow_id" msprop:Generator_ColumnPropNameInRow="flow_id" msprop:Generator_ColumnPropNameInTable="flow_idColumn" msprop:Generator_UserColumnName="flow_id" type="xs:int" />
              <xs:element name="flowStatus" msprop:Generator_ColumnVarNameInTable="columnflowStatus" msprop:Generator_ColumnPropNameInRow="flowStatus" msprop:Generator_ColumnPropNameInTable="flowStatusColumn" msprop:Generator_UserColumnName="flowStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EmploeeTask" msprop:Generator_TableClassName="EmploeeTaskDataTable" msprop:Generator_TableVarName="tableEmploeeTask" msprop:Generator_TablePropName="EmploeeTask" msprop:Generator_RowDeletingName="EmploeeTaskRowDeleting" msprop:Generator_RowChangingName="EmploeeTaskRowChanging" msprop:Generator_RowEvHandlerName="EmploeeTaskRowChangeEventHandler" msprop:Generator_RowDeletedName="EmploeeTaskRowDeleted" msprop:Generator_UserTableName="EmploeeTask" msprop:Generator_RowChangedName="EmploeeTaskRowChanged" msprop:Generator_RowEvArgName="EmploeeTaskRowChangeEvent" msprop:Generator_RowClassName="EmploeeTaskRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="task_name" msprop:Generator_ColumnVarNameInTable="columntask_name" msprop:Generator_ColumnPropNameInRow="task_name" msprop:Generator_ColumnPropNameInTable="task_nameColumn" msprop:Generator_UserColumnName="task_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="task_id" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
              <xs:element name="task_description" msprop:Generator_ColumnVarNameInTable="columntask_description" msprop:Generator_ColumnPropNameInRow="task_description" msprop:Generator_ColumnPropNameInTable="task_descriptionColumn" msprop:Generator_UserColumnName="task_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="output_description" msprop:Generator_ColumnVarNameInTable="columnoutput_description" msprop:Generator_ColumnPropNameInRow="output_description" msprop:Generator_ColumnPropNameInTable="output_descriptionColumn" msprop:Generator_UserColumnName="output_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="flow_id" msprop:Generator_ColumnVarNameInTable="columnflow_id" msprop:Generator_ColumnPropNameInRow="flow_id" msprop:Generator_ColumnPropNameInTable="flow_idColumn" msprop:Generator_UserColumnName="flow_id" type="xs:int" />
              <xs:element name="flowStatus" msprop:Generator_ColumnVarNameInTable="columnflowStatus" msprop:Generator_ColumnPropNameInRow="flowStatus" msprop:Generator_ColumnPropNameInTable="flowStatusColumn" msprop:Generator_UserColumnName="flowStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EmployeeRole" msprop:Generator_TableClassName="EmployeeRoleDataTable" msprop:Generator_TableVarName="tableEmployeeRole" msprop:Generator_TablePropName="EmployeeRole" msprop:Generator_RowDeletingName="EmployeeRoleRowDeleting" msprop:Generator_RowChangingName="EmployeeRoleRowChanging" msprop:Generator_RowEvHandlerName="EmployeeRoleRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeeRoleRowDeleted" msprop:Generator_UserTableName="EmployeeRole" msprop:Generator_RowChangedName="EmployeeRoleRowChanged" msprop:Generator_RowEvArgName="EmployeeRoleRowChangeEvent" msprop:Generator_RowClassName="EmployeeRoleRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="role_id" msprop:Generator_ColumnVarNameInTable="columnrole_id" msprop:Generator_ColumnPropNameInRow="role_id" msprop:Generator_ColumnPropNameInTable="role_idColumn" msprop:Generator_UserColumnName="role_id" type="xs:int" />
              <xs:element name="emp_role" msprop:Generator_ColumnVarNameInTable="columnemp_role" msprop:Generator_ColumnPropNameInRow="emp_role" msprop:Generator_ColumnPropNameInTable="emp_roleColumn" msprop:Generator_UserColumnName="emp_role" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ViewAdmin" msprop:Generator_TableClassName="ViewAdminDataTable" msprop:Generator_TableVarName="tableViewAdmin" msprop:Generator_TablePropName="ViewAdmin" msprop:Generator_RowDeletingName="ViewAdminRowDeleting" msprop:Generator_RowChangingName="ViewAdminRowChanging" msprop:Generator_RowEvHandlerName="ViewAdminRowChangeEventHandler" msprop:Generator_RowDeletedName="ViewAdminRowDeleted" msprop:Generator_UserTableName="ViewAdmin" msprop:Generator_RowChangedName="ViewAdminRowChanged" msprop:Generator_RowEvArgName="ViewAdminRowChangeEvent" msprop:Generator_RowClassName="ViewAdminRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emp_id" msprop:Generator_ColumnVarNameInTable="columnemp_id" msprop:Generator_ColumnPropNameInRow="emp_id" msprop:Generator_ColumnPropNameInTable="emp_idColumn" msprop:Generator_UserColumnName="emp_id" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="taskInProgress" msprop:Generator_ColumnVarNameInTable="columntaskInProgress" msprop:Generator_ColumnPropNameInRow="taskInProgress" msprop:Generator_ColumnPropNameInTable="taskInProgressColumn" msprop:Generator_UserColumnName="taskInProgress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="task_id" msprop:Generator_ColumnVarNameInTable="columntask_id" msprop:Generator_ColumnPropNameInRow="task_id" msprop:Generator_ColumnPropNameInTable="task_idColumn" msprop:Generator_UserColumnName="task_id" type="xs:int" />
              <xs:element name="task_name" msprop:Generator_ColumnVarNameInTable="columntask_name" msprop:Generator_ColumnPropNameInRow="task_name" msprop:Generator_ColumnPropNameInTable="task_nameColumn" msprop:Generator_UserColumnName="task_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="task_description" msprop:Generator_ColumnVarNameInTable="columntask_description" msprop:Generator_ColumnPropNameInRow="task_description" msprop:Generator_ColumnPropNameInTable="task_descriptionColumn" msprop:Generator_UserColumnName="task_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="output_description" msprop:Generator_ColumnVarNameInTable="columnoutput_description" msprop:Generator_ColumnPropNameInRow="output_description" msprop:Generator_ColumnPropNameInTable="output_descriptionColumn" msprop:Generator_UserColumnName="output_description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="flow_id" msprop:Generator_ColumnVarNameInTable="columnflow_id" msprop:Generator_ColumnPropNameInRow="flow_id" msprop:Generator_ColumnPropNameInTable="flow_idColumn" msprop:Generator_UserColumnName="flow_id" type="xs:int" />
              <xs:element name="flowStatus" msprop:Generator_ColumnVarNameInTable="columnflowStatus" msprop:Generator_ColumnPropNameInRow="flowStatus" msprop:Generator_ColumnPropNameInTable="flowStatusColumn" msprop:Generator_UserColumnName="flowStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Emp_Task" />
      <xs:field xpath="mstns:emptask_id" />
    </xs:unique>
    <xs:unique name="Employee_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Employee" />
      <xs:field xpath="mstns:emp_id" />
    </xs:unique>
    <xs:unique name="EmpRole_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EmpRole" />
      <xs:field xpath="mstns:role_id" />
    </xs:unique>
    <xs:unique name="TaskTable_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TaskTable" />
      <xs:field xpath="mstns:task_id" />
    </xs:unique>
    <xs:unique name="WorkFlow_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkFlow" />
      <xs:field xpath="mstns:flow_id" />
    </xs:unique>
    <xs:unique name="EmploeeTask_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EmploeeTask" />
      <xs:field xpath="mstns:emp_id" />
      <xs:field xpath="mstns:task_id" />
      <xs:field xpath="mstns:flow_id" />
    </xs:unique>
    <xs:unique name="EmployeeRole_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EmployeeRole" />
      <xs:field xpath="mstns:role_id" />
    </xs:unique>
    <xs:unique name="ViewAdmin_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ViewAdmin" />
      <xs:field xpath="mstns:emp_id" />
      <xs:field xpath="mstns:task_id" />
      <xs:field xpath="mstns:flow_id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK__Emp_Task__emp_id__1A14E395" msdata:parent="Employee" msdata:child="Emp_Task" msdata:parentkey="emp_id" msdata:childkey="emp_id" msprop:Generator_UserChildTable="Emp_Task" msprop:Generator_ChildPropName="GetEmp_TaskRows" msprop:Generator_UserRelationName="FK__Emp_Task__emp_id__1A14E395" msprop:Generator_RelationVarName="relationFK__Emp_Task__emp_id__1A14E395" msprop:Generator_UserParentTable="Employee" msprop:Generator_ParentPropName="EmployeeRow" />
      <msdata:Relationship name="FK__Emp_Task__task_i__38996AB5" msdata:parent="TaskTable" msdata:child="Emp_Task" msdata:parentkey="task_id" msdata:childkey="task_id" msprop:Generator_UserChildTable="Emp_Task" msprop:Generator_ChildPropName="GetEmp_TaskRows" msprop:Generator_UserRelationName="FK__Emp_Task__task_i__38996AB5" msprop:Generator_RelationVarName="relationFK__Emp_Task__task_i__38996AB5" msprop:Generator_UserParentTable="TaskTable" msprop:Generator_ParentPropName="TaskTableRow" />
      <msdata:Relationship name="FK__Employee__role_i__145C0A3F" msdata:parent="EmpRole" msdata:child="Employee" msdata:parentkey="role_id" msdata:childkey="role_id" msprop:Generator_UserChildTable="Employee" msprop:Generator_ChildPropName="GetEmployeeRows" msprop:Generator_UserRelationName="FK__Employee__role_i__145C0A3F" msprop:Generator_RelationVarName="relationFK__Employee__role_i__145C0A3F" msprop:Generator_UserParentTable="EmpRole" msprop:Generator_ParentPropName="EmpRoleRow" />
      <msdata:Relationship name="FK__TaskTable__flow___36B12243" msdata:parent="WorkFlow" msdata:child="TaskTable" msdata:parentkey="flow_id" msdata:childkey="flow_id" msprop:Generator_UserChildTable="TaskTable" msprop:Generator_ChildPropName="GetTaskTableRows" msprop:Generator_UserRelationName="FK__TaskTable__flow___36B12243" msprop:Generator_RelationVarName="relationFK__TaskTable__flow___36B12243" msprop:Generator_UserParentTable="WorkFlow" msprop:Generator_ParentPropName="WorkFlowRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>